Create Dimensions and Fact Tables in OLAP Database and Populate the Dimension and Fact Tables 13

Download the SQL File attached to the 

Run Script that is attached to Dimensions and Fact Tables in OLAP Database. Once ran, the tables will be made up of these columns.




After creating the Dimensions and Fact tables in OLAP Database

Stored Procedure to populate DimDate, attached to the




For Merge Statement Stored Procedures, SQL files attached to the













Execute packages to populate the Dimensions and Fact tables with the data





 

The Dimensions and Fact tables are populated  with the data




INCREMENTAL DATA LOAD IN SSIS